using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data.Common; 

namespace DataBaseManager
{
    class SQLServerDataTypeProvider:IDataTypeProvider 
    {
        public DbParameter AddParameterWithValue(DbParameterCollection parameters, string parameterName, object value)
        {
            return ((SqlParameterCollection)(parameters)).AddWithValue(parameterName, value);
        }

        public DbCommand GetNewDBCommand()
        {
            return new SqlCommand();
        }

        public DbConnection GetNewDBConnection()
        {
            return new SqlConnection();
        }

        public DbParameter GetNewDBParameter()
        {
            return new SqlParameter();
        }
    }
}
